package com.spring.mybatis.mapper;

import com.spring.mybatis.model.ArticleInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface ArticleInfoMapper {
    @Select("SELECT * from article_info ta " +
            "left join user_info tb ON tb.id = ta.uid " +
            "where ta.id = #{id}")
    ArticleInfo selectArticleInfoAndUserInfo(Integer id);
}
